//
//  Account.h
//  soccer
//
//  Created by 上官千城 on 15/9/14.
//  Copyright (c) 2015年 上官千城. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "Register.h"
#import "MainSetting.h"
#import "Preference.h"
@interface Account : NSObject
//调用数据库方法
+(instancetype)shareHandle;
//打开数据库
-(void)openDB;
//创建注册页面
-(void)createRegisterTable;
//添加注册用户
-(void)insertRegister:(Register *)reg;
//根据ID删除对应注册账号
-(void)deleteRegister:(NSString *)personID;
//选择注册用户
-(NSMutableArray *)selectAllRegister;
//删除注册表
-(void)dropRegisterTable;

//创建个人信息列表
-(void)createMainSettingTable;
//添加个人设置信息
-(void)insertMainSetting:(MainSetting *)set;
//根据ID删除对应个人设置信息
-(void)deleteMainSetting:(NSString *)userID;
//选择个人设置信息
-(NSMutableArray *)selectMainSetting;
//删除个人设置信息
-(void)dropMainSettingTable;


//创建偏好设置页面
-(void)createPreferenceTable;
//删除偏好设置表
-(void)dropPreferenceTable;
//选择偏好设置
-(NSMutableArray *)selectAllPreference;
//添加偏好设置
-(void)insertPreference:(Preference *)pre;




@end
